-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: mysql5.cws.oregonstate.edu
-- Generation Time: May 22, 2019 at 12:40 PM
-- Server version: 5.1.63
-- PHP Version: 5.3.3-7+squeeze9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `cw_61046`
--

-- --------------------------------------------------------

--
-- Table structure for table `CodesAppOld`
--

CREATE TABLE IF NOT EXISTS `CodesAppOld` (
  `ManagCode` text NOT NULL,
  `ManagDescrip` text NOT NULL,
  `ManagType` text NOT NULL,
  `ManagNotes` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CodesAppOld`
--

INSERT INTO `CodesAppOld` (`ManagCode`, `ManagDescrip`, `ManagType`, `ManagNotes`) VALUES
('0N15P0K', 'NPK fertilizer: 0-15-0 (superphosphate)', 'APP_MATER', ''),
('15.5N0P0K', 'NPK fertilizer: 15.5-0-0 (calcium nitrate)', 'APP_MATER', ''),
('16N20P0K', 'NPK fertilizer: 16-20-0', 'APP_MATER', ''),
('18N46P0K', 'NPK fertilizer: 18-46-0', 'APP_MATER', ''),
('CAC', 'Calcium carbonate (CaCO3)', 'APP_MATER', ''),
('CAC_AND_CAO', 'Calcium carbonate (CaCO3) and Calcium oxide (CaO)', 'APP_MATER', ''),
('CAM', 'Calcium-magnesium carbonate (CaMg(CO3)2)', 'APP_MATER', ''),
('CAO', 'Calcium oxide (CaO)', 'APP_MATER', ''),
('CASSAVA', 'Cassava plant material (tubers: soaked, dried, and ground)', 'APP_MATER', ''),
('CHICK', 'Chicken manure (air dried, may include straw, rice hull, etc.)', 'APP_MATER', ''),
('COW', 'Cow  manure', 'APP_MATER', ''),
('CYPERUS', 'Cyperus plant material', 'APP_MATER', ''),
('DAP', 'Di-ammonium phosphate ((NH4)2-HPO4)', 'APP_MATER', ''),
('DGRASS', 'Dry-grass plant material', 'APP_MATER', ''),
('FEED', 'Fish feed (feed type and composition are given under application materials)', 'APP_MATER', ''),
('FEED1', 'Additional fish feed type, when > 1 feed types used', 'APP_MATER', ''),
('FEED2', 'Additional fish feed type, when > 2 feed types used', 'APP_MATER', ''),
('FEED3', 'Additional fish feed type, when > 3 feed types used', 'APP_MATER', ''),
('GALL', 'Gall plant material', 'APP_MATER', ''),
('GGRASS', 'Green-grass plant material', 'APP_MATER', ''),
('MGERM', 'Maize germ', 'APP_MATER', ''),
('NAC', 'Sodium carbonate (Na2CO3)', 'APP_MATER', ''),
('NAHCO3', 'Sodium bicarbonate (NaHCO3)', 'APP_MATER', ''),
('NH4PO4', 'Ammonium phosphate (NH4-H2PO4)', 'APP_MATER', ''),
('RBRAN', 'Rice bran (not de-fatted)', 'APP_MATER', ''),
('SP', 'Super phosphate (???% P)', 'APP_MATER', ''),
('SP_OR_TSP', 'Super phosphate or Triple super phosphate', 'APP_MATER', ''),
('TITON', 'Titonia plant material (Compositae family; shrub, leaves used)', 'APP_MATER', ''),
('TSP', 'Triple super phosphate: 0N-46P-0K, 42% P2O5', 'APP_MATER', ''),
('UNKNOWN', 'Unknown', 'APP_MATER', ''),
('UREA', 'Urea nitrogren: 47N-0P-0K', 'APP_MATER', '');
